View Materialization in a Data Cube: Optimization Models and Heuristics
نویسندگان
چکیده
منابع مشابه
A Parallel Adaptive Partial Materialization Method of Data Cube Based on Genetic Algorithm
Due to the limitation of computing and storage resources, online analysis of massive data is usually time consuming. Data cube materialization is an effective way to improve the performance of online analysis. Considering the potential parallelism of genetic algorithm and its good global searching ability, a materialization method of data cube based on genetic algorithm is proposed. This method...
متن کاملCooperative Heuristics for the Federated View Selection Problem
The federated view selection problem (FVSP) is an optimization technique designed to enhance query performance in a federated data warehouse environment through the materialization of select views given resource constraints and storage restrictions. Current research focuses on single-instance heuristics, which have difficulty scaling. In this work, we introduce two commonly used cooperative heu...
متن کاملSelection of Views to Materialize in
A data warehouse stores materialized views of data from one or more sources, with the purpose of eeciently implementing decision-support or OLAP queries. One of the most important decisions in designing a data warehouse is the selection of materialized views to be maintained at the warehouse. The goal is to select an appropriate set of views that minimizes total query response time and the cost...
متن کاملThe Federated View Selection Problem
Database federation is becoming an increased reality for business and clinical organizations due to rapid data accumulation, making a single, monolithic data warehouse difficult to achieve. A commonly used technique to decrease query execution time in data warehousing environments is to precompute and store beneficial views. Known as the view selection problem, this process seeks to identify th...
متن کاملM Aterialization Is a Vailable
The role of materialized views is becoming vital in today’s distributed Data warehouses. Materialization is where parts of the data cube are pre-computed. Some of the real time distributed architectures are maintaining materialization transparencies in the sense the users are not known with the materialization at a node. Usually what all followed by them is a cache maintenance mechanism where t...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- J. Database Manag.
دوره 18 شماره
صفحات -
تاریخ انتشار 2007